/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_attr_spec_his.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_ATTR_SPEC_HIS
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_attr_spec_his.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_ATTR_SPEC_HIS::CTable_PPM_ATTR_SPEC_HIS( )
 :NPCRecordSet( )
{
  setTableName( "PPM_ATTR_SPEC_HIS" );
  prepareTable();
  prepareQuery();
 
  HIS_ID.setField( "HIS_ID", DATA_CHAR, 20, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  ATTR_ID.setField( "ATTR_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ATTR_ID );
  ATTR_CD.setField( "ATTR_CD", DATA_CHAR, 30, 0 );
  makeTableItem( ATTR_CD );
  ATTR_NAME.setField( "ATTR_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( ATTR_NAME );
  DESCRIBE.setField( "DESCRIBE", DATA_CHAR, 2048, 0 );
  makeTableItem( DESCRIBE );
  ATTR_VALUE_CODE.setField( "ATTR_VALUE_CODE", DATA_CHAR, 20, 0 );
  makeTableItem( ATTR_VALUE_CODE );
  DEFAULT_VALUE.setField( "DEFAULT_VALUE", DATA_CHAR, 256, 0 );
  makeTableItem( DEFAULT_VALUE );
  VALUE_FROM.setField( "VALUE_FROM", DATA_CHAR, 256, 0 );
  makeTableItem( VALUE_FROM );
  VALUE_TO.setField( "VALUE_TO", DATA_CHAR, 256, 0 );
  makeTableItem( VALUE_TO );
  IS_UNIQUE.setField( "IS_UNIQUE", DATA_CHAR, 6, 0 );
  makeTableItem( IS_UNIQUE );
  IS_NULLABLE.setField( "IS_NULLABLE", DATA_CHAR, 6, 0 );
  makeTableItem( IS_NULLABLE );
  STATE_CD.setField( "STATE_CD", DATA_CHAR, 6, 0 );
  makeTableItem( STATE_CD );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  SEND_OSS.setField( "SEND_OSS", DATA_CHAR, 6, 0 );
  makeTableItem( SEND_OSS );
  IS_DEFAULT.setField( "IS_DEFAULT", DATA_CHAR, 6, 0 );
  makeTableItem( IS_DEFAULT );
  IS_REQUIRED.setField( "IS_REQUIRED", DATA_CHAR, 6, 0 );
  makeTableItem( IS_REQUIRED );
  VALUE_TYPE.setField( "VALUE_TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( VALUE_TYPE );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  REGULAR_EXP.setField( "REGULAR_EXP", DATA_CHAR, 512, 0 );
  makeTableItem( REGULAR_EXP );
  GROUP_PROD_ATTR.setField( "GROUP_PROD_ATTR", DATA_CHAR, 20, 0 );
  makeTableItem( GROUP_PROD_ATTR );
  PARAM_TYPE.setField( "PARAM_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( PARAM_TYPE );
  PARAM_LENGTH.setField( "PARAM_LENGTH", DATA_CHAR, 20, 0 );
  makeTableItem( PARAM_LENGTH );
  STAFF.setField( "STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( STAFF );
	ATTR_TYPE.setField( "ATTR_TYPE", DATA_CHAR, 5, 0 );
  makeTableItem( ATTR_TYPE );
}


CTable_PPM_ATTR_SPEC_HIS::CTable_PPM_ATTR_SPEC_HIS( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_ATTR_SPEC_HIS" );
  prepareTable();
  prepareQuery();
 
  HIS_ID.setField( "HIS_ID", DATA_CHAR, 20, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  ATTR_ID.setField( "ATTR_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ATTR_ID );
  ATTR_CD.setField( "ATTR_CD", DATA_CHAR, 30, 0 );
  makeTableItem( ATTR_CD );
  ATTR_NAME.setField( "ATTR_NAME", DATA_CHAR, 512, 0 );
  makeTableItem( ATTR_NAME );
  DESCRIBE.setField( "DESCRIBE", DATA_CHAR, 2048, 0 );
  makeTableItem( DESCRIBE );
  ATTR_VALUE_CODE.setField( "ATTR_VALUE_CODE", DATA_CHAR, 20, 0 );
  makeTableItem( ATTR_VALUE_CODE );
  DEFAULT_VALUE.setField( "DEFAULT_VALUE", DATA_CHAR, 256, 0 );
  makeTableItem( DEFAULT_VALUE );
  VALUE_FROM.setField( "VALUE_FROM", DATA_CHAR, 256, 0 );
  makeTableItem( VALUE_FROM );
  VALUE_TO.setField( "VALUE_TO", DATA_CHAR, 256, 0 );
  makeTableItem( VALUE_TO );
  IS_UNIQUE.setField( "IS_UNIQUE", DATA_CHAR, 6, 0 );
  makeTableItem( IS_UNIQUE );
  IS_NULLABLE.setField( "IS_NULLABLE", DATA_CHAR, 6, 0 );
  makeTableItem( IS_NULLABLE );
  STATE_CD.setField( "STATE_CD", DATA_CHAR, 6, 0 );
  makeTableItem( STATE_CD );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  SEND_OSS.setField( "SEND_OSS", DATA_CHAR, 6, 0 );
  makeTableItem( SEND_OSS );
  IS_DEFAULT.setField( "IS_DEFAULT", DATA_CHAR, 6, 0 );
  makeTableItem( IS_DEFAULT );
  IS_REQUIRED.setField( "IS_REQUIRED", DATA_CHAR, 6, 0 );
  makeTableItem( IS_REQUIRED );
  VALUE_TYPE.setField( "VALUE_TYPE", DATA_CHAR, 6, 0 );
  makeTableItem( VALUE_TYPE );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  REGULAR_EXP.setField( "REGULAR_EXP", DATA_CHAR, 512, 0 );
  makeTableItem( REGULAR_EXP );
  GROUP_PROD_ATTR.setField( "GROUP_PROD_ATTR", DATA_CHAR, 20, 0 );
  makeTableItem( GROUP_PROD_ATTR );
  PARAM_TYPE.setField( "PARAM_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( PARAM_TYPE );
  PARAM_LENGTH.setField( "PARAM_LENGTH", DATA_CHAR, 20, 0 );
  makeTableItem( PARAM_LENGTH );
  STAFF.setField( "STAFF", DATA_CHAR, 20, 0 );
  makeTableItem( STAFF );
	ATTR_TYPE.setField( "ATTR_TYPE", DATA_CHAR, 5, 0 );
  makeTableItem( ATTR_TYPE );
}

CTable_PPM_ATTR_SPEC_HIS::~CTable_PPM_ATTR_SPEC_HIS( )
{
    close();
}

